package com.gljx.web.service;

import com.gljx.web.Entity.SubjectTwoResult;
import com.gljx.web.Entity.User;

import java.util.List;
import java.util.Map;

public interface SubjectTwoResultService {
	Map<String, Object> selectPageCount(String psql);

    Map<String, Object> selectPage(int pindex, String psql, int psize);
    
    /**
   	 * 查找最大编码
   	 * @return
   	 */
   	String selectFnumber(String companyId);
   	/**
   	 * 增加科目二考试登记信息
   	 * @param subjectTwoResult
   	 * @return
   	 */
   	int addSubjectTwoResult(User user,SubjectTwoResult subjectTwoResult,String [] stuid,String [] stufseq,String [] stucfzkzmbh,String [] stufnumber,String [] stuname,
   			String [] stucfidcardno,String [] stucfsex,String [] stucfsjhm,String [] stucflxdh,String [] stucfslzjcxdh,String [] stucfclazzName,
   			String [] stucfamount,String [] stucfreceived,String [] stucfarrearage,String [] stucffavorable,String [] stucfvip,String [] stucflocal,
   			String [] stucfexamresult,String [] stucfremark);
   	/**
   	 * 根据fid删除
   	 * @param fid
   	 * @return
   	 */
   	int deleteSubjectTwoResult(String fid);

	/**
	 * 提交
	 * @param subjectTwoResult
	 * @return
	 */
	int submitSubjectTwoResult(SubjectTwoResult subjectTwoResult);
   	/**
   	 * 根据fid查找科目二考试结果登记信息
   	 * @param fid
   	 * @return
   	 */
   	SubjectTwoResult selSubjectTwoResultByFid(String fid);
   	/**
   	 * 审核
   	 * @param subjectTwoResult
   	 */
   	int updateSubjectTwoResult(SubjectTwoResult subjectTwoResult);
   	/**
   	 * 修改
   	 * @param user
   	 * @param subjectTwoResult
   	 * @param stuid
   	 * @param stufseq
   	 * @param stucfzkzmbh
   	 * @param stufnumber
   	 * @param stuname
   	 * @param stucfidcardno
   	 * @param stucfsex
   	 * @param stucfsjhm
   	 * @param stucflxdh
   	 * @param stucfslzjcxdh
   	 * @param stucfclazzName
   	 * @param stucfamount
   	 * @param stucfreceived
   	 * @param stucfarrearage
   	 * @param stucffavorable
   	 * @param stucfvip
   	 * @param stucflocal
   	 * @param stucfexamresult
   	 * @param stucfremark
   	 */
	int updateSubjectTwoResult(User user,SubjectTwoResult subjectTwoResult,String [] stuid,String [] stufseq,String [] stucfzkzmbh,String [] stufnumber,String [] stuname,
   			String [] stucfidcardno,String [] stucfsex,String [] stucfsjhm,String [] stucflxdh,String [] stucfslzjcxdh,String [] stucfclazzName,
   			String [] stucfamount,String [] stucfreceived,String [] stucfarrearage,String [] stucffavorable,String [] stucfvip,String [] stucflocal,
   			String [] stucfexamresult,String [] stucfremark);

	List<SubjectTwoResult> selectSubjectTwoResult(String companyId,String fnumber,String fdescription,String beginTime,String endTime);
}
